import sqlite3

conn = sqlite3.connect('db_test.sqlite3')
cur = conn.cursor()
# cur.execute('''create table userinfor(
#     username char(16) not null,
#     password char(16) not null,
#     idCard char(18) primary key not null,
#     phone char(11) not null)''')
# cur.execute('''create table fruitPrice(
#     apple real not null,
#     pear real not null,
#     banana real not null,
#     orange real not null,
#     litchi real not null,
#     grapefruit real not null)''')
# cur.execute('''create table fruitForm(
#     username char(16) primary key not null,
#     apple_num real,
#     apple_price real,
#     pear_num real,
#     pear_price real,
#     banana_num real,
#     banana_price real,
#     orange_num real,
#     orange_price real,
#     litchi_num real,
#     litchi_price real,
#     grapefruit_num real,
#     graprfruit_price real,
#     jackfruit_num real,
#     jackfruit_price real,
#     oneFruitPrice real not null)''')
# cur.execute('''create table FruitForm(
#     username char(16) primary key not null,
#     fruit_Name real not null,
#     fruit_Price real not null,
#     fruit_Weight real not null,
#     oneFruitPrice real not null)''')
cur.execute('''create table orderForm(
    id integer primary key AUTOINCREMENT,
    username char(16) not null,
    data text not null,
    address text not null,
    phone text not null,
    amount real not null)''')
